<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class install extends CI_Controller{
	public function index()
	{
		$sql=array();
		// $sql[]='drop table if exists `<?php`';
		// $sql[]='create table `<?php` (
		// 	`_id` int PRIMARY KEY not null
		// )';
		$sql[]='drop table if exists `hope`';
		$sql[]='create table `hope` (
			`hope_id` int PRIMARY KEY AUTO_INCREMENT not null,
			`content` text not null,
			`time` int not null,
			`name` varchar(30) not null,
			`icon` varchar(999) not null,
			`paper` varchar(30)
		)ENGINE=InnoDB DEFAULT CHARSET=utf8';
		foreach($sql as $s){
			var_dump($this->db->query($s));
		}
	}
}
?>